package com.itheima.mapper;

import com.itheima.bean.Student;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface StudentForTeacher {
    @Select("SELECT s.id,s.name,s.age FROM student s,stu_tch st WHERE s.id=st.sid and #{id}=st.tid")
    public List<Student> selectAll(Integer id);
}
